PM Transaction WORK File (PM10000)

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Transaction WORK File (PM10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PM10000

Product: Microsoft Dynamics GP (0)
Series: Purchasing

Display Name: PM Transaction WORK File
Physical Name: PM10000
Technical Name: PM_Transaction_WORK

Group Display Name: Payables Transaction Logical File
Group Technical Name: PM_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BACHNUMB	Batch Number	String	STR15_LBAU	15
	Partial key to the Posting Definitions Master (SY00500). Click to show/hide SELECT ['PM Transaction WORK File'].BACHNUMB AS 'PM Transaction WORK File-Batch Number' ,['Posting Definitions Master'].BACHNUMB AS 'Posting Definitions Master-Batch Number' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN SY00500 AS ['Posting Definitions Master'] ON ['PM Transaction WORK File'].BACHNUMB = ['Posting Definitions Master'].BACHNUMB AND ['PM Transaction WORK File'].BCHSOURC = ['Posting Definitions Master'].BCHSOURC
2	BCHSOURC	Batch Source	String	STR15	15
	Records whether the transaction was entered in a batch or not. Click to show/hide the Batch Sources PM_Trxent Batch XXPM_Trxent No batch (real-time)
3	VCHNUMWK	Voucher Number - WORK	String	STR17_LBAU	17
4	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['PM Transaction WORK File'].VENDORID AS 'PM Transaction WORK File-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['PM Transaction WORK File'].VENDORID = ['PM Vendor Master File'].VENDORID
5	DOCNUMBR	Document Number	String	STR20_Document_Number	20
6	DOCTYPE	Document Type	Integer	DDL_Document_Type	0
	Click to show/hide Document Types 1 Invoice 2 Finance Charge 3 Miscellaneous Charges 4 Return 5 Credit Memo
7	SOURCDOC	Source Document	String	STR10_Source_Document	10
	Key to the Source Document Master (SY00900). Click to show/hide SELECT ['PM Transaction WORK File'].SOURCDOC AS 'PM Transaction WORK File-Source Document' ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN SY00900 AS ['Source Document Master'] ON ['PM Transaction WORK File'].SOURCDOC = ['Source Document Master'].SOURCDOC
8	DOCAMNT	Document Amount	Currency	DLR19_RBSO_UTR$	19
9	DOCDATE	Document Date	Date	DT	8
10	PSTGDATE	Posting Date	Date	DT	8
11	VADDCDPR	Vendor Address Code - Primary	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['PM Transaction WORK File'].VADDCDPR AS 'PM Transaction WORK File-Vendor Address Code - Primary' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['PM Transaction WORK File'].VADDCDPR = ['PM Address MSTR'].ADRSCODE AND ['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID
12	VADCDTRO	Vendor Address Code - Remit To	String	STR15_Address_Code	15
	Partial key to the PM Address MSTR (PM00300). Click to show/hide SELECT ['PM Transaction WORK File'].VADCDTRO AS 'PM Transaction WORK File-Vendor Address Code - Remit To' ,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN PM00300 AS ['PM Address MSTR'] ON ['PM Transaction WORK File'].VADCDTRO = ['PM Address MSTR'].ADRSCODE AND ['PM Transaction WORK File'].VENDORID = ['PM Address MSTR'].VENDORID
13	PYMTRMID	Payment Terms ID	String	STR20_Payment_Terms_ID	20
	Key to the Payment Terms Master (SY03300). Click to show/hide SELECT ['PM Transaction WORK File'].PYMTRMID AS 'PM Transaction WORK File-Payment Terms ID' ,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN SY03300 AS ['Payment Terms Master'] ON ['PM Transaction WORK File'].PYMTRMID = ['Payment Terms Master'].PYMTRMID
14	TAXSCHID	Tax Schedule ID	String	STR15_Tax_Schedule_ID	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Transaction WORK File'].TAXSCHID AS 'PM Transaction WORK File-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Transaction WORK File'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
15	DUEDATE	Due Date	Date	DT	8
16	DSCDLRAM	Discount Dollar Amount	Currency	DLR11_RBS0_UTR$	11
17	DISCDATE	Discount Date	Date	DT	8
18	PRCHAMNT	Purchases Amount	Currency	DLR17_RBS0_UTR$	17
19	CHRGAMNT	Charge Amount	Currency	DLR19_RBSO_UTR$	19
20	CASHAMNT	Cash Amount	Currency	DLR19_RBS0_UTR$	19
21	CAMCBKID	Cash Amount Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PM Transaction WORK File'].CAMCBKID AS 'PM Transaction WORK File-Cash Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PM Transaction WORK File'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID
22	CDOCNMBR	Cash Document Number	String	STR20_Document_Number	20
23	CAMTDATE	Cash Amount Date	Date	DT	8
24	CAMPMTNM	Cash Amount Payment Number	String	STR20_LBAU	20
25	CHEKAMNT	Check Amount	Currency	DLR19_RBS0_UTR$	19
26	CHAMCBID	Check Amount Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PM Transaction WORK File'].CHAMCBID AS 'PM Transaction WORK File-Check Amount Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PM Transaction WORK File'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID
27	CHEKDATE	Check Date	Date	DATE	6
28	CAMPYNBR	Check Amount Payment Number	String	STR20_LBAU	20
29	CRCRDAMT	Credit Card Amount	Currency	DLR19_RBS0_UTR$	19
30	CCAMPYNM	Credit Card Amount Payment Number	String	STR20_LBAU	20
31	CHEKNMBR	Check Number	String	STR20_Document_Number	20
32	CARDNAME	Card Name	String	STR15_Card_Name	15
33	CCRCTNUM	Credit Card Receipt Number	String	STR20_Document_Number	20
34	CRCARDDT	Credit Card Date	Date	DATE	6
35	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['PM Transaction WORK File'].CURNCYID AS 'PM Transaction WORK File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['PM Transaction WORK File'].CURNCYID = ['Currency Setup'].CURNCYID
36	CHEKBKID	Checkbook ID	String	STR15_Checkbook_ID	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['PM Transaction WORK File'].CHEKBKID AS 'PM Transaction WORK File-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['PM Transaction WORK File'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
37	TRXDSCRN	Transaction Description	String	STR30	30
38	UN1099AM	Unapplied 1099 Amount	Currency	DLR17_RBS0_UTR$	17
39	TRDISAMT	Trade Discount Amount	Currency	DLR17_RBS0_UTR$	17
40	TAXAMNT	Tax Amount	Currency	DLR17_RBS0_UTR$	17
41	FRTAMNT	Freight Amount	Currency	DLR17_RBS0_UTR$	17
42	TEN99AMNT	1099 Amount	Currency	DLR17_RBS0_UTR$	17
43	MSCCHAMT	Misc Charges Amount	Currency	DLR17_RBS0_UTR$	17
44	PORDNMBR	Purchase Order Number	String	Purchase Order Number	20
45	SHIPMTHD	Shipping Method	String	STR15_Shipping_Method	15
	Key to the Shipping Methods Master (SY03000). Click to show/hide SELECT ['PM Transaction WORK File'].SHIPMTHD AS 'PM Transaction WORK File-Shipping Method' ,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN SY03000 AS ['Shipping Methods Master'] ON ['PM Transaction WORK File'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD
46	DISAMTAV	Discount Amount Available	Currency	DLR17_RBS0_UTR$	17
47	DISTKNAM	Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
48	APDSTKAM	Applied Discount Taken Amount	Currency	DLR17_RBS0_UTR$	17
49	WROFAMNT	Write Off Amount	Currency	DLR17_RBS0_STR$	17
50	CURTRXAM	Current Trx Amount	Currency	DLR17_RBS0_UTR$	17
51	TXENGCLD	Tax Engine Called	Boolean	YN	0
52	PMWRKMSG	PM WORK Messages	Long Integer	ML_PM_WORK_Messages	0
53	PMDSTMSG	PM Distribution Messages	Long Integer	ML_PM_Distribution_Messages	0
54	GSTDSAMT	GST Discount Amount	Currency	DLR17_RBS0_STR$	17
55	PGRAMSBJ	Percent Of Gross Amount Subject	Integer	INT5_RBS2_U%	5
56	PPSAMDED	PPS Amount Deducted	Currency	DLR17_RBS0_UTR$	17
57	PPSTAXRT	PPS Tax Rate	Integer	INT5_%2	5
58	PSTGSTUS	Posting Status	Integer	INT	0
	Click to show/hide Posting Status 10 A transaction being entered for the first time, before it has been saved by the used. 20 A saved but unposted transaction. 30 A transaction that is currently realtime posting. 40 A posted transaction. 50 A transactions that has encountered an error during posting. 60 A transaction that has been saved previously and has a status of 20 is now being edited by the user. 70 A transaction that has been posted previously in a recurring batch that still contains unposted transactions is now being edited by the user.
59	POSTED	Posted	Boolean	True/False	0
60	APPLDAMT	Applied Amount	Currency	DLR17_RBS0_STR$	17
61	VCHRNMBR	Voucher Number	String	STR20_LBAU	20
	Partial key to the PM Key Master File (PM00400). Click to show/hide SELECT ['PM Transaction WORK File'].VCHRNMBR AS 'PM Transaction WORK File-Voucher Number' ,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN PM00400 AS ['PM Key Master File'] ON ['PM Transaction WORK File'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM AND ['PM Transaction WORK File'].DOCTYPE = ['PM Key Master File'].DOCTYPE
62	CNTRLTYP	Control Type	Integer	INT1	1
	The Control Type records the type of transaction. Click to show/hide Control Types 0 Voucher types 1 Payment types 2 Printed alignment forms
63	MODIFDT	Modified Date	Date	DT	8
64	MDFUSRID	Modified User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Transaction WORK File'].MDFUSRID AS 'PM Transaction WORK File-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Transaction WORK File'].MDFUSRID = ['Users Master'].USERID
65	POSTEDDT	Posted Date	Date	DATE	6
66	PTDUSRID	Posted User ID	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['PM Transaction WORK File'].PTDUSRID AS 'PM Transaction WORK File-Posted User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['PM Transaction WORK File'].PTDUSRID = ['Users Master'].USERID
67	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['PM Transaction WORK File'].NOTEINDX AS 'PM Transaction WORK File-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['PM Transaction WORK File'].NOTEINDX = ['Record Notes Master'].NOTEINDX
68	BKTFRTAM	Backout Freight Amount	Currency	DLR19_RBS0_UTR$	19
69	BKTMSCAM	Backout Misc Amount	Currency	DLR19_RBS0_UTR$	19
70	BKTPURAM	Backout Purchases Amount	Currency	DLR19_RBS0_UTR$	19
71	PCHSCHID	Purchase Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Transaction WORK File'].PCHSCHID AS 'PM Transaction WORK File-Purchase Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Transaction WORK File'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
72	FRTSCHID	Freight Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Transaction WORK File'].FRTSCHID AS 'PM Transaction WORK File-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Transaction WORK File'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
73	MSCSCHID	Misc Schedule ID	String	STR15_LBAU	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['PM Transaction WORK File'].MSCSCHID AS 'PM Transaction WORK File-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM PM10000 AS ['PM Transaction WORK File'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['PM Transaction WORK File'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
74	PRINTED	Printed	Boolean	CB	0
	Click to show/hide Printed flag 0 Record has not been printed. 1 Record has been printed.
75	PRCTDISC	Percent Discount	Integer	INT5_%2	5
76	RETNAGAM	Retainage Amount	Currency	DLR17_RBS0_UTR$	17
77	ICTRX	IC TRX	Boolean	CB_IC_TRX	0
	Click to show/hide Intercompany flag 0 Not intercompany. 1 Intercompany
78	ICDISTS	ICDists	Boolean	Boolean	0
	Click to show/hide Intercompany distirubtions 0 Not intercompany. 1 Intercompany distributions present.
79	PMICMSGS	ICMessages	Long Integer	ML_IC_Post_Messages	0
	Error messages from posting an Intercompany Transaction. Click to show/hide Intercompany posting error messages 1 The currency ID is missing. 2 A destination company does not have access to this currency ID. 3 The currency ID is inactive for a destination company. 4 A rate type ID is missing for a destination company. 5 Rate type ID is not associated with the currency ID for a destination company. 6 An exchange table ID is missing for a destination company. 7 A destination company does not have access to an exchange table ID. 8 An exchange table ID is inactive for a destination company. 9 An exchange rate does not exist for a destination company. 10 An exchange rate has expired for a destination company. 11 Cannot post intercompany multicurrency transactions to a recurring batch. 12 A rounding account missing for a destination company. 13 A distribution type is invalid for a destination company distribution. 14 A destination company distribution contains MDA information. 15 A destination company ID does not exist; please select another company ID. 16 The user does not have access to a destination company. 17 A destination company does not have a functional currency set up. 18 Destination functional currency doesn't match originating functional currency. 19 No relationship exists between originating company and a destination company. 20 Due To / Due From account not specified. 21 The rounding account does not exist for the originating company. 22 Unknown SQL error occurred. 23 Intrastat information is missing or invalid. 24 The goods value for Intrastat exceeds the document total. 25 Transaction has successfully posted.
80	Tax_Date	Tax Date	Date	DT	8
81	PRCHDATE	Purchase Date	Date	DT	8
82	CORRCTN	Correction	Boolean	CB_Correction	0
83	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
84	CORRNXST	Correction to Nonexisting Transaction	Boolean	Boolean	0
85	VCHRNCOR	Voucher Number Corrected	String	STR20_LBAU	20
86	PMWRKMS2	PM WORK Messages 2	Long Integer	ML_PM_WORK_Messages_2	0
87	BNKRCAMT	Bank Receipts Amount	Currency	DLR17_RBS0_STR$	17
88	APLYWITH	Apply Withholding	Boolean	Boolean	0
89	Electronic	Electronic	Boolean	CB_Electronic	0
90	ECTRX	EC Transaction	Boolean	CB_EC_Transaction	0
	The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction. Click to show/hide Document Printed flag 0 Not an EU Transaction. 1 EU Transaction.
91	DocPrinted	DocPrinted	Boolean	CB_DocPrinted	0
	Click to show/hide Document Printed flag 0 Record has not been printed. 1 Record has been printed.
92	TaxInvReqd	Tax Invoice Required	Boolean	CB_Tax_Invoice_Required	0
93	BackoutTradeDisc	Backout Trade Discount Amount	Currency	DLR19_RBS0_UTR$	19
94	CBVAT	Cash Based VAT	Boolean	CB_CashBasedVAT	0
95	TEN99TYPE	1099 Type	Integer	1099_Type	0
96	TEN99BOXNUMBER	1099 Box Number	Integer	DDL_1099_Box	0
97	Workflow_Status	Workflow Status	Integer	Workflow Status	0
98	InvoiceReceiptDate	Invoice Receipt Date	Date	DT	8
	Invoice Receipt Date is only available in a UK install of Microsoft Dynamics GP. It was introduced due to changes in UK legislation which came into force on 1st April 2017 for business of a certain size which now have duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardise their ability to trade.
99	LNGDESC	Long Description2	String	STR200	200

azurecurve Products Microsoft Dynamics GP (0)PurchasingPM Transaction WORK File (PM10000)

Leave a Reply Cancel reply